alter table jms_dm.dm_tab_transfer_mail_network_summary_dt set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_tab_transfer_mail_network_summary_dt;
create table if not exists jms_dm.dm_tab_transfer_mail_network_summary_dt
(
    date_time        string comment '日期',
    scan_site_code   string comment '扫描站点',
    input_site       string comment '扫描站点',
    agent_code       string comment '代理区code',
    agent_name       string comment '代理区名称',
    transfer_num     int comment '转邮扫描量',
    yes_del_num      int comment '转邮打标',
    no_del_num       int comment '转邮未打标',
    cnyz_arr_num     int comment '邮政到件量',
    all_sig_num      int comment '总签收量',
    cnyz_sig_num     int comment '邮政签收量',
    network_sign_num int comment '网点签收量',
    remark1          int comment '轨迹完整量：（邮政揽收量+邮政签收量）按单号去重',
    remark2          string comment '备用字段'
)
    comment '转邮监控汇总'
    partitioned by (dt string comment '扫描时间yyyy-MM-dd')
    stored as parquet
    location '/dw/hive/jms_dm.db/external/dm_tab_transfer_mail_network_summary_dt'